<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@page import="Model_Db.DbUtil"%>
<%@page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>已读信息</title>
</head>
<body>
	<jsp:useBean id="b" class="Model_Db.DbUtil" ></jsp:useBean>
	<% 
	String s="1";
	String sql="select * from t_feedback where f_flag='"+s+"'";
    ResultSet rs=b.QuerySQL(sql);
	rs.last();
	%>
	<table border="1" style="background-color:#C4FFC9;text-align:center;border:0.1px solid #E51094 ;" >
		<tr><td style="width:80px">记录条数</td><td style="width:100px">医生ID号</td><td style="width:100px">姓名</td>
			<td style="width:400px">上报信息</td><td style="width:100px">查上报时间</td><td style="width:80px">查询状态</td></tr>
		<% rs.beforeFirst();
		while(rs.next()){
		%>
		<tr>
			<td><%=rs.getRow() %></td>
			<td><%=rs.getString("doctor_id") %></td>
			<td><%=rs.getString("doctor_name") %></td>
			<td><%=rs.getString("f_massage") %></td>
			<td><%=rs.getString("f_date") %></td>
			<td>已读</td>
		</tr>
		
	
		<%}%>
	</table>
	
</body>
</html>